CREATE TABLE [dbo].[Classes] (
    [ID]             INT           IDENTITY (1, 1) NOT NULL,
    [SubjectID]      INT           NOT NULL,
    [ClassStartTime] TIME (7)      NOT NULL,
    [ClassEndTime]   TIME (7)      NOT NULL,
    [WorkDayID]      INT           NOT NULL,
    [ClassNumber]    INT           NULL,
    [LetureRoom]     NVARCHAR (50) NULL,
    [TeacherID]      INT           NULL,
    [BuildingID]     INT           NOT NULL
);







